<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en">
  <title id="ev138336">gp_configuration_history</title>
  <body>
    <p>The <codeph>gp_configuration_history</codeph> table contains information about system changes
      related to fault detection and recovery operations. The <codeph>fts_probe</codeph> process
      logs data to this table, as do certain related management utilities such as
        <codeph>gprecoverseg</codeph> and <codeph>gpinitsystem</codeph>.
      For example, when you add a new segment and mirror segment to the system, records for these
      events are logged to <codeph>gp_configuration_history</codeph>.</p>
    <p otherprops="pivotal">The event descriptions stored in this table may be helpful for troubleshooting serious system
      issues in collaboration with VMware Support technicians.</p>
    <p>This table is populated only on the master. This table is defined in the
        <codeph>pg_global</codeph> tablespace, meaning it is globally shared across all databases in
      the system.</p>
    <table id="ev138428">
      <title>pg_catalog.gp_configuration_history</title>
      <tgroup cols="4">
        <colspec colnum="1" colname="col1" colwidth="96.75pt"/>
        <colspec colnum="2" colname="col2" colwidth="97pt"/>
        <colspec colnum="3" colname="col3" colwidth="121.5pt"/>
        <colspec colnum="4" colname="col4" colwidth="138pt"/>
        <thead>
          <row>
            <entry colname="col1">column</entry>
            <entry colname="col2">type</entry>
            <entry colname="col3">references</entry>
            <entry colname="col4">description</entry>
          </row>
        </thead>
        <tbody>
          <row>
            <entry colname="col1">
              <codeph>time</codeph>
            </entry>
            <entry colname="col2">timestamp with time zone</entry>
            <entry colname="col3"/>
            <entry colname="col4">Timestamp for the event recorded.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph id="ev138567">dbid</codeph>
            </entry>
            <entry colname="col2">smallint</entry>
            <entry colname="col3">gp_segment_configuration.dbid</entry>
            <entry colname="col4">System-assigned ID. The unique identifier of a segment (or master)
              instance.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>desc</codeph>
            </entry>
            <entry colname="col2">text</entry>
            <entry colname="col3"/>
            <entry colname="col4">Text description of the event.</entry>
          </row>
        </tbody>
      </tgroup>
    </table>
    <p>For information about <codeph>gprecoverseg</codeph> and <codeph>gpinitsystem</codeph>, see the Greenplum Database
      Utility Guide.</p>
  </body>
</topic>
